package project.innovation.mooddiagnosis.dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import project.innovation.mooddiagnosis.entity.scaleScore.ScaleScore;

import java.util.List;

public interface ScaleRecordMapper {
    @Insert("INSERT INTO scale VALUES (#{scoreId},#{userId},#{violence},#{empathy},#{alert},#{lie},#{prosocial},#{selfEsteem },#{selfControl},#{values},#{socialSupport},#{nonsuicidalSelfInjury},#{suicidalTendency},#{emotionRegulation},#{abnormalPsychology},#{negativeCognitiveBias})")
    int insert(ScaleScore score);
    @Select("SELECT * FROM scale WHERE userId = #{userId}")
    List<ScaleScore> selectByUserId(String userId);
}
